To modify a custom table
Caution! If your custom table contains customized objects (triggers, additional indexes, special permissions), they will be lost when the table is rebuilt.
- Make sure all other users exit the iMIS system.
- Back up your data.
- Log on as the database owner: MANAGER!SA (Sybase: MANAGER!DBA)
- From Customers, select Set up module> General, and click Additional Windows to open the Customer Setup – Additional Windows window.
- Click Define Tables to open the User Defined Tables window.
- Select the Table Name drop-down list, and select the table you want to modify.
- Make the necessary changes:
- To add a field to the table, place the cursor anywhere in the field row where you want the new field to follow, and click Insert Line on the User Defined Tables window. A new field row is inserted, and the new field information can be added here.
- To delete a field on the table, place the cursor anywhere in the field, and click Delete Line on the User Defined Tables window.
- To reorder the fields, select the field, and click Up or Down on the User Defined Tables window.
- Click Save. iMIS prompts you to update the server table.
- Click Yes.
- Click OK if prompted to restart iMIS.
- Click Auto-Create Window.
- Click Close to close the User Defined Tables window.
- Exit iMIS immediately.
- Refresh the iMIS libraries by replacing the existing imismem.lbr and imisutil.lbr files with a clean copy of these files.
Note: If you copy the library files from a CD, make sure to disable the Read only option.